package com.bookstore.admin.product.dao;

import com.bookstore.commons.beans.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * company: www.abc.com
 * Author: Administrator
 * Create Data: 2021/6/2 0002
 */
public interface AdminProductDao {
    List<Product> selectProductList();

    Product selectProductById(String id);

    int deleteProduct(String id);

    int updateProduct(Product product);

    List<Product> selectProductByManyCondition(@Param("product") Product product, @Param("minprice") Double minprice, @Param("maxprice") Double maxprice);

    int selectCount(Product product, Double minprice, Double maxprice);

    List<ProductList> selectProductSalList(@Param("year")String year,@Param("month") String month);

    int insertProduct(Product product);

    List<Order> selectOrderList(Order order);


    List<Orderitem> selectOrderItemById(String id);

    List<Notice> selectNotice();

    Notice selectByIdNoticeServlet(Integer id);

    int updateNoticeService(Notice notice);

    int delectNoticeService(Integer id);

    int addNoticeServlet(Notice notice);

    Integer selectUser(@Param("logonName") String logonName, @Param("logonPwd") String logonPwd);
}
